package com.orphan.marketBack.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.orphan.marketBack.dto.OrderMaintenanceDto;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;
@Repository("OrderMaintenanceMapper")
public interface OrderMaintenanceMapper extends BaseMapper<OrderMaintenanceDto> {
    /**
     *
     * 订单维护，查看所有订单信息
     * @return
     */
    @Select("select order_id,order_no,goods_name,goods_type,goods_price,goods_count,goods_order_status,order_time,pay_method from order2,order_detail3\n")
    List<OrderMaintenanceDto> selectOrderMaintenance();

    //根据商品名称查询订单
    List<OrderMaintenanceDto> selectOrderMaintenanceByGoodsName(OrderMaintenanceDto orderMaintenanceDto);
}
